import xlrd
def extract(inpath):
data = xlrd.open_workbook(inpath, encoding_override='utf-8')
table = data.sheets()[0] # 选定表
nrows = table.nrows # 获取行号
ncols = table.ncols # 获取列号
all_info =[]
teacher = getnew(inpathnew)
print(teacher)
# print(nrows)
for i in range(0, nrows): # 第0行为表头
if i == 10:
break
else:
alldata = table.row_values(i) # 循环输出excel表中每一行,即所有数据
result = alldata[
python爬取两个excel表里的相同数据并匹配输出
最新推荐文章于 2024-09-02 23:57:56 发布